var DBConfig = {
    mysql: {
        host: '106.15.229.111',
		user: 'root',	
		password: 'jkyx123456',	
		database: 'yymxwuhan',
		multipleStatements: true,
		port: '3306'
    },
    mysql2: {
        host: '106.15.229.111',
		user: 'root',	
		password: 'jkyx123456',	
		database: 'jkyx',
		multipleStatements: true,
		port: '3306'
    },
    // 查询用户
    getAccountByAccount: 'select * from account where account = ?;',
    // 查询openid
    getOpendiByOpenid: 'select * from account where openid = ?',
    // 发送验证码
    sendVarcode: 'insert into account_identify_code (account,identify_code,create_time) values (?,?,?); insert into sms_logs (account,template,create_time) values (?,?,?)',
	// 获取验证码
	getVarcodeByAccount: 'select * from account_identify_code where account = ? and status = 1 order by create_time desc',
	// 验证码过期
	varCode_isOver: 'update account_identify_code  set status = 2 where account = ?',
	login_check: 'select * from account where account = ?;select * from account_identify_code where account = ? and status = 1 order by create_time desc;',
	// 登录
	loginWithAccount: 'update account_identify_code  set status = 2 where account = ?; insert into login_logs (account,type,ip,province,city,area,create_time) values (?,?,?,?,?,?,?); select * from account where account = ?',
	// 退出登录
	loginOutWithAccount: 'insert into login_logs (account,type,ip,province,city,area,create_time) values (?,?,?,?,?,?,?);',
	// 注册
	registerWithAccount: 'update account_identify_code  set status = 2 where account = ?;insert into account (account_id,account,create_time) values (?,?,?);insert into login_logs (account,type,ip,province,city,area,create_time) values (?,?,?,?,?,?,?); select account_id,account,nickname,birthday,balance from account where account = ?',
	// 更新用户openid
	updateOpenid: 'update account_identify_code  set status = 2 where account = ?;update account set openid = ? where account = ?;insert into login_logs (account,type,ip,province,city,area,create_time) values (?,?,?,?,?,?,?); select account,nickname,birthday,balance from account where account = ?',
	// 更新用户微信信息
	updateWxInfo: 'update account set wx_nickname = ?,avatarUrl = ?,gender = ? where openid = ?',
	// 暂存微信opendi
	insertWxOpenID: 'insert into wx_login (openid,create_time) values (?,?)',
	
	
	// 获取商品分类
	getGoodsClassify: 'select * from goods_classify where level = 1 and show_status = 1 order by sort asc;',
	// 获取 商品列表
	getGoodsByClassify: 'select id,name from goods_classify where pid = ? and level = 2 and show_status = 1 order by sort asc; SELECT * FROM goods WHERE id IN (select goods_id FROM goods_classify_relation WHERE classify_id = ?) AND status =2 order by id asc; select * from goods_spec where goods_id in (select goods_id FROM goods_classify_relation WHERE classify_id = ?) and status = 1',
	// 获取商品详情
	getGoodsDetailByID: 'select * from goods where id = ?;select * from comment where goods_id = ? order by id desc;select * from goods_spec where goods_id = ? and status = 1 order by price asc;select count(*) from cart where account_id = ? and status = 1;select status from collection where account_id = ? and goods_id = ?;insert into footprint (account_id,goods_id,create_time) values (?,?,?)',
	// 获取购物车列表
	getCartList: 'select * from cart where account_id = ? and status = 1 order by create_time desc',
	// 购物车添加商品
	insertCart: 'insert into cart (account_id,goods_id,spec_id,num,status,create_time) values (?,?,?,?,?,?); select * from cart where account_id = ? and status = 1 order by create_time desc',
	// 更改购物车中商品数量
	updateCart: 'update cart set num = ? where id = ? and status = 1; select * from cart where account_id = ? and status = 1 order by create_time desc',
	// 获取购物车中某一条记录
	getCartOneList: 'select * from cart where account_id = ? and goods_id = ? and spec_id = ? and status = 1',
	// 购物车中删除一个商品 
	delectOndCartList: 'update cart set status = 3 where id = ?;select * from cart where account_id = ? and status = 1 order by create_time desc',
	// 删除购物车中的一个商品
	delectOndCartList2: 'update cart set status = 3 where account_id = ? and goods_id = ? and spec_id = ?;select * from cart where account_id = ? and status = 1 order by create_time desc',
	// 获取热门搜索
	getAllHotSearch: 'select * from hot_search where status = 1 order by sort asc',
	// 添加商品收藏
	goodsCollection: 'update collection set status = ? where account_id = ? and goods_id = ?',
	// 获取某个商品是否收藏
	getgoodsCollection: 'select status from collection where account_id = ? and goods_id = ?',  
	// 获取用户收藏
	getgoodsCollections: 'select * from goods where id in (select goods_id from collection where account_id = ? and status = 1);select * from goods_spec where goods_id in (select goods_id from collection where account_id = ? and status = 1) and status = 1;',
	// 删除某个足迹
	deleteCollectionByID: 'update collection set status = 2 where account_id = ? and goods_id = ?',
	// 删除全部足迹
	deleteCollection: 'update collection set status = 2 where account_id = ? ',
	// 获取用户足迹
	getFootprint: 'select * from goods where id in (select goods_id from footprint where account_id = ? and status = 1);select * from goods_spec where goods_id in (select goods_id from footprint where account_id = ? and status = 1) and status = 1;',
	// 删除某个足迹
	deleteFootprintByID: 'update footprint set status = 2 where account_id = ? and goods_id = ?',
	// 删除全部足迹
	deleteFootprint: 'update footprint set status = 2 where account_id = ? ',
	// 用户地址列表
	getAddressByAccountID: 'select * from receiving_info where account_id = ? and status = 1 order by is_default asc;',
	// 获取地区数据
	gerRegionInfo: 'select * from region where region_id in (?,?,?,?)',
	// 获取 街道信息
	getRegionList: 'select * from region where parent_id in (select region_id from region where parent_id = 180);',
	// 设置默认地址
	updateReceviceDefault: 'update receiving_info set is_default = 2 where account_id = ?; update receiving_info set is_default = 1 where account_id = ? and id = ?',
	// 删除地址
	deleteRecevice: 'update receiving_info set status = 2 where account_id = ? and id = ?',
	// 获取某个区的街道
	getJiedao: 'select region_id,region_name from region where parent_id = ?',
	// 修改地址
	editAddress: 'update receiving_info set consignee = ?,mobile_number = ?,areas_id = ?,area_id = ?,address = ? where account_id = ? and id = ?',
	// 新增地址
	newAddress: 'insert into receiving_info (mallid,account_id,consignee,province_id,city_id,areas_id,area_id,mobile_number,address,create_time) values (8,?,?,13,180,?,?,?,?,?)',
	// 获取账户余额
	getBalance: 'select balance from account where account_id = ?',
	// 获取支付密码
	getPayPw: 'select pay_password from account where account_id = ?',
	// 设置支付密码
	setPayPW: 'update account set pay_password = ? where account_id = ?',
	// 微信支付成功
	paySuccess: 'update orders set payment_id = ?,recharge_pay_amount = ?,pay_amount_other = ?,pay_timer = ?,shipping_timer = ?,order_status = 2,transaction_id = ? where account_id = ? and order_no = ?',
	// 使用了余额的支付成功
	paySuccess2: 'update orders set payment_id = ?,recharge_pay_amount = ?,pay_amount_other = ?,pay_timer = ?,shipping_timer = ?,order_status = 2,transaction_id = ? where account_id = ? and order_no = ?;update account set balance = ? where account_id = ?; insert into rechange_record (account_id,amount,create_time,order_no) values (?,?,?,?)',
	// 支付失败
	payFail: 'update orders set payment_id = ?,recharge_pay_amount = ?,pay_amount_other = ?,shipping_timer = ?,order_status = 1 where account_id = ? and order_no = ?;',
	// 获取订单列表
	getOrderList: 'select * from orders where account_id = ? and status = 1 order by create_time desc',
	// 分类获取订单
	getOrderListByType: 'select * from orders where account_id = ? and status = 1 and order_status = ? and shipping_status = ? order by create_time desc',
	// 获取订单详情
	getOrderDetail: 'select * from orders where account_id = ? and id = ?; select region_name from region where region_id in (select province_id from orders where id = ?);select region_name from region where region_id in (select city_id from orders where id = ?);select region_name from region where region_id in (select areas_id from orders where id = ?);select region_name from region where region_id in (select area_id from orders where id = ?);select * from mail_admin where id in (select shooper_id from orders where id = ?);',
	// 删除订单
	deleteOrderByID: 'update orders set status = 2 where account_id = ? and id = ?',
	// 取消订单
	cancelOrderByID: 'update orders set order_status = 3 where account_id = ? and order_no = ?;update coupon_bind set status = 1 where id = ?',
	// 订单退款 -- 全部退款
	getRefundOrder: 'select * from orders where order_no = ?;update orders set order_status = 7 where order_no = ?; select balance from account where account_id = ?;',
	// 修改用户余额
	updateBalance: 'update account set balance = ? where account_id = ?;insert into rechange_record (account_id,amount,type,create_time) values (?,?,?,?)',  
	// 发表评价 1.修改订单评价字段为已评价状态 2.插入评价数据
	updateOrderComment: 'update orders set is_comment = 2,order_status = 6 where id = ?;',
	// 充值成功
	rechargeSuccess: 'update account set balance = ? where account_id = ?;insert into rechange_record (account_id,amount,type,create_time,order_no,transaction_id) values (?,?,3,?,?,?)',
	// 领卷中心
	conpouCenter: 'select * from jkyx_coupon where status = 1 and is_delete = 1',
	// 领取优惠券
	recviceConpou: 'insert into jkyx_coupon_bind (coupon_id,account_id,create_time) values (?,?,?);',
	// 用户是否领取过优惠券
	isRecviceConpou: 'select * from jkyx_coupon_bind where coupon_id = ? and account_id = ?;',
	// 用户的卡卷中心
	conpouUserList: 'select a.coupon_id,a.account_id,a.status,a.create_time, b.is_delete,b.status, b.name,b.type,b.manzu,b.youhui,b.start_time,b.end_time,b.overdue_time,b.available_num,b.total_num from jkyx_coupon_bind as a left join jkyx_coupon as b on a.coupon_id = b.id where a.account_id = ? and b.status = 1 and b.is_delete = 1;',
	// 改变用户优惠券状态
	changeConpouStatus: 'update jkyx_coupon_bind set status = ? where coupon_id = ? and account_id = ?;',
	// 获取优惠券详情
	conpouDetail: 'select * from jkyx_coupon where id = ?;',

// ---------- PC端
    // 获取商品列表 上架商品
	pc_get_goods: 'SELECT * FROM goods WHERE id IN (select goods_id FROM goods_classify_relation) AND status =2 order by id asc; select * from goods_spec where goods_id in (select goods_id FROM goods_classify_relation) and status = 1',
	// 获取商品列表 下架商品
	pc_get_goods2: 'SELECT * FROM goods WHERE id IN (select goods_id FROM goods_classify_relation) AND status =3 order by id asc; select * from goods_spec where goods_id in (select goods_id FROM goods_classify_relation) and status = 1',
	// 获取商品列表 删除商品
	pc_get_goods3: 'SELECT * FROM goods WHERE id IN (select goods_id FROM goods_classify_relation) AND status =4 order by id asc; select * from goods_spec where goods_id in (select goods_id FROM goods_classify_relation) and status = 1',
	// 获取商品详情
	pc_goods_detail: 'select * from goods where id = ?; select * from goods_spec where goods_id = ? and status = 1; select * from goods_classify where id in (select classify_id FROM goods_classify_relation where goods_id = ?)',
	// 保存商品规格
	pc_save_spec: 'update goods_spec set price = ?,origprice = ?,spec = ?,salecount = ?,erpcode = ?,stock = ?, sort = ? where id = ?;select * from goods_spec where goods_id = ? and status = 1',
	// 删除商品规格
	pc_delete_spec: 'update goods_spec set status = 2 where id = ?;select * from goods_spec where goods_id = ? and status = 1',
	// 新增商品规格
	pc_new_spec: 'insert into goods_spec (goods_id,price,origprice,spec,salecount,erpcode,stock,status,sort,create_time) values (?,?,?,?,?,?,?,?,?,?);select * from goods_spec where goods_id = ? and status = 1',
	// 保存商品信息
	pc_save_goods: 'update goods set name = ?,descr = ?,pre_sale_time = ?,create_time = ?,imgs = ?,detail_imgs = ? where id = ?',
    // 图片上传
    pc_upload_image: 'insert into imgstore (admin_id,imgpath,create_time) values (?,?,?)',
    // 商品下架
    pc_xia_goods: 'update goods set status = 3 where id = ?',
    // 商品删除
    pc_delete_goods: 'update goods set status = 4 where id = ?',
    // 商品上架
    pc_shang_goods: 'update goods set status = 2 where id = ?',
    // 新增商品
    pc_add_goods: 'insert into goods (goods_id,name,descr,imgs,detail_imgs,status,sort,pre_sale_time,create_time) values ("A",?,?,?,?,3,0,?,?); select * from goods where goods_id = "A"',
	// 获取商品一级分类
	pc_GoodsClassify: 'select * from goods_classify where level = 1 and show_status = 1 order by sort asc;',
	// 获取商品二级分类
	pc_GoodsClassify2: 'select * from goods_classify where level = 2 and show_status = 1 order by sort asc;',
	// 获取商品所有分类
	pc_AllClassify: 'select * from goods_classify where level = 1 and show_status != 3 order by sort asc; select * from goods_classify where level = 2 and show_status != 3 order by sort asc;',
	// 获取分组下的商品
	pc_GoodsByClassify: 'select * from goods where id in (select goods_id from goods_classify_relation where classify_id = ?) and status = 2',
    // 删除某个分类
    pc_deletc_classify: 'update goods_classify set show_status = 3 where id = ?',
    // 保存分类修改
    pc_save_classify: 'update goods_classify set pid = ?,name = ?,`desc` = ?, logo = ?,sort = ?,show_status = ?,update_time = ? where id = ?',
    // 新建分类
    pc_new_classify: 'insert into goods_classify (level,pid,name,`desc`,logo,sort,create_time,update_time,show_status,deleted,mallid) values (?,?,?,?,?,?,?,?,?,0,8)',
    // 新增热门搜索
	pc_new_hotSearch: 'insert into hot_search (keyword,sort,status,create_time) values (?,?,?,?);select * from hot_search where status = 1 order by sort asc',
	// 删除一个热门搜索
	pc_delete_HotSearchByID: 'update hot_search set status = 2 where id = ?;select * from hot_search where status = 1 order by sort asc',
	// 编辑一个热门搜索
	pc_edit_HotSearchByID: 'update hot_search set keyword = ?,sort = ? where id = ?;select * from hot_search where status = 1 order by sort asc',
    // 订单列表
    pc_order_list: 'select count(*) from orders where status = 1 and add_time > ?;select * from orders where status = 1 and add_time > ? order by create_time desc limit ?,?',
    // 订单详情
    pc_order_detail: 'select * from orders where status = 1 and id = ?',
    // 修改订单备注
    pc_modify_order_mark: 'update orders set remark = ?,descr = ? where id = ?',
    // 修改订单价格
    pc_modify_order_amount: 'update orders set pay_amount = ? where id = ?;',
    // 后台管理人员登录
    pc_user_login: 'update mail_admin set lastlogin = ? where telno = ? and passwd = ?;select id,name,telno from mail_admin where telno = ? and passwd = ?',
    // PC后台接口请求记录
    pc_request_list: 'insert into request_list (telno,request_name,create_time) values (?,?,?)',
    // 获取用户余额和消费记录
    pc_get_balance: 'select account_id,account,wx_nickname,avatarUrl,balance from account  where account = ?; select * from rechange_record where account_id in (select account_id from account  where account = ?) order by id desc;',
    // 修改用户余额
    pc_change_balance: 'update account set balance = ? where account_id = ?; insert into rechange_record (account_id,amount,create_time,type) values (?,?,?,3)',
    // 获取优惠券 列表
    pc_get_conpou: 'select * from jkyx_coupon;select * from jkyx_coupon limit ?,?',
    // 新建优惠券
    pc_add_conpou: 'insert into jkyx_coupon (name,type,manzu,youhui,start_time,end_time,overdue_time,available_num,total_num,status,is_delete,create_time) values (?,?,?,?,?,?,?,?,?,?,?,?)',
    // 启用优惠券
    pc_open_conpou: 'update jkyx_coupon set status = 1 where id = ?',
    // 停用优惠券
    pc_close_conpou: 'update jkyx_coupon set status = 2 where id = ?',
    // 删除优惠券
    pc_delete_conpou: 'update jkyx_coupon set is_delete = 2 where id = ?',
    // 编辑优惠券
    pc_edit_conpou: 'update jkyx_coupon set name = ?,type = ?,manzu = ?,youhui = ?,start_time = ?,end_time = ?,overdue_time = ?,total_num = ?,status = ?,available_num = ? where id = ?',
    // 优惠券详情
    pc_detail_conpou: 'select * from jkyx_coupon where id = ?;',
    // 新建轮播图
    pc_banners_new: 'insert into jkyx_banners (type,image_url,goods_id,create_time) values (?,?,?,?); select * from jkyx_banners where status = 1;',
    // 获取轮播图 列表
    pc_banners_list: 'select * from jkyx_banners where status = 1;',
    // 编辑修改 轮播图
    pc_banners_edit: 'update jkyx_banners set type = ?,image_url = ? where id = ?;',
    // 删除 轮播图
    pc_banners_delete: 'update jkyx_banners set status = 2 where id = ?;select * from jkyx_banners where status = 1;',
    // 新增首页信息
    pc_home_add: 'insert into jkyx_home (index_num,image_url,goods_ids,create_time) values (?,?,?,?);',
    // 获取首页列表
    pc_home_list: 'select * from jkyx_home where status = 1 order by index_num desc;',
    // 删除首页
    pc_home_delete: 'update jkyx_home set status = 2 where id = ?;',
    // 编辑首页
    pc_home_edit: 'update jkyx_home set index_num = ?,image_url = ?,goods_ids = ? where id = ?;',
    // 充值设置-新增
	pc_recharge_add: 'insert into jkyx_recharge (recharge_money,gift_money,start_time,end_time,create_time) values (?,?,?,?,?);',
	// 获取充值列表
	pc_recharge_list: 'select * from jkyx_recharge where status = 1 order by recharge_money asc;',
	// 删除一个充值
	pc_recharge_delete: 'update jkyx_recharge set status = 2 where id = ?;',
    
    
// 数据库复制
	// 获取评价
	getGoodsByComment: 'select * from yymx_comment;',
	// 商品和分类的关系
	getGoods_classify_relation: 'select * from yymx_mallgoodsgrprel',
	// 获取分类
	getGoods_classify: 'select * from yymx_mallgoodsgrp',
	// 获取全部上传的图片
	getImages: 'select * from yymx_imgstore',
	// 复制商品
	getGoods: 'select * from yymx_mallgoodsspu;select * from yymx_mallgoodssku',
	// 复制订单
	getOrders: 'select * from yymx_orders;',
	// 复制系统用户信息
	getMalladmin: 'select name,telno,passwd,sex from yymx_malladmin;',
	getGoods: 'select * from yymx_mallgoodsspu;select * from yymx_mallgoodssku',
	// 复制用户信息
	getYymxAccount: 'select * from yymx_account',	
	
    //添加优惠券规则
	addCouponRules: 'insert into coupon_rule (name,type,param,add_time,use_type,commodit_id) values (?,?,?,?,?,?)',
	//修改优惠券规则
	updateCouponRules: 'update coupon_rule set name = ?,type = ?,param = ?, update_time = ? use_type = ?, commodit_id = ? where id = ?;select * from coupon_rule where id = ?',
	//优惠券规则列表
	couponRulsList: 'select * from coupon_rule where is_del = 0 limit ?,?',
	//获取优惠券规则
	getOneCouponRule: 'select * from coupon_rule where id = ? and is_del = 0',
	//删除优惠券规则
	deleteCouponRule: 'update coupon_rule set is_del = 1 where id = ?',
	//添加优惠券
	addCoupon: 'insert into coupon (name,quantity,person_limit,start_time,end_time,valid_start,valid_end,coupon_rules_id,coupon_type,release_status,status,promotion_mode,add_time) values (?,?,?,?,?,?,?,?,?,?,?,?,?)',
	//修改优惠券
	updateCoupon: 'update coupon set name = ?, quantity = ?,person_limit = ?,start_time = ?,end_time = ?,valid_start = ?,valid_end = ?,coupon_rules_id = ?,coupon_type = ?,release_status = ?,status = ?,promotion_mode = ?, update_time = ? where id = ?;select * from coupon where id = ?',
	//删除优惠券
	deleteCoupon: 'update coupon set is_del = 1 where id = ?',
	//优惠券列表
	couponList: 'select * from coupon where is_del = 0 limit ?,?',
	//优惠券详情
	getCoupon: 'select * from coupon where id = ? order by id desc; select * from coupon_rule where id in (select coupon_rules_id from coupon where id = ? order by id desc)',
	//启用优惠券
	open_closeCoupon: 'update coupon set status = ? where id = ?', // 1:启用  0:停用
	
	
	//优惠券领券中心
	getValidCoupon: 'select c.id as id,c.name as name,quantity,person_limit,receive_num,valid_start,valid_end,param from coupon as c inner join coupon_rule as r on c.coupon_rules_id = r.id where c.promotion_mode = 1 and c.start_time < ? and c.end_time > ? and c.status = 1 and c.is_del = 0 and r.use_type <> ?',
	//优惠券领取
	receiveCoupon: 'insert into coupon_bind (coupon_id,account_id,status,bind_time) values (?,?,?,?)',
  updateCouponNumber: 'update coupon set receive_num = receive_num+1 where id = ?',
  //获取优惠券数量
  getCouponNum: 'select * from coupon where id = ?;select count(*) as total from coupon_bind where coupon_id = ? and account_id = ?',
	//用户优惠券列表
	userCouponList: 'select cb.id,c.name,c.valid_start,c.valid_end,cb.bind_time,cr.param from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and c.valid_start < ? and c.valid_end > ? and cb.status = ? and c.is_del = 0 limit ?,?',
	userCouponListCount: 'select count(*) as totalCount from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and c.valid_start < ? and c.valid_end > ? and cb.status = ? and c.is_del = 0',
	userCouponEnd: 'select cb.id,c.name,c.valid_start,c.valid_end,c.add_time,cr.param from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and c.valid_end < ? and c.is_del = 0 limit ?,?',
  userCouponEndCount : 'select count(*) as totalCount from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and c.valid_end < ? and c.is_del = 0',
  userHasUsedCoupon: 'select cb.id,c.name,c.valid_start,c.valid_end,c.add_time,cr.param from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and cb.status = ? and c.is_del = 0 limit ?,?',
  userHasUsedCouponCount: 'select count(*) as totalCount from (coupon_bind as cb left join coupon as c on cb.coupon_id = c.id) left join coupon_rule as cr on c.coupon_rules_id = cr.id where cb.account_id = ? and cb.status = ? and c.is_del = 0',
  //购物车商品优惠券
  getGoodsCoupon: 'select c.id, c.name,c.valid_start,c.valid_end,cr.param from coupon as c left join coupon_rule as cr on c.coupon_rules_id = cr.id where c.start_time < ? and c.end_time > ? and c.status = ? and c.promotion_mode = ? and c.is_del = 0 and cr.use_type = ? and commodit_id = ?',
  //购物车商品优惠券领取
  receiveGoodsCoupon: 'insert into coupon_bind (coupon_id,account_id,status,bind_time) values (?,?,?,?);update coupon set receive_num = receive_num+1 where id = ?',
  //用户使用优惠券
  useCoupon: 'update coupon_bind set status = ? where id = ?',
  //充值设置
  rechargeSettingAdd: 'insert into recharge_setting (charge_amount,gift_amount,gift_type,start_time,end_time,add_time,update_time) values (?,?,?,?,?,?,?)',
  rechargeSettingUpdate: 'update recharge_setting set charge_amount = ?,gift_amount = ?,gift_type = ?,start_time = ?,end_time = ?,update_time = ? where id = ?',
  getRechargeSettingOne: 'select * from recharge_setting where id = ?',
  delRechargeSetting: 'update recharge_setting set is_del = 2 where id = ?',
  getRechargeSettingList: 'select * from recharge_setting where is_del = 1'
   
}
module.exports = DBConfig;


/*
 *  CREATE DATABASE `jkyx` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
 * 
 * 
CREATE TABLE IF NOT EXISTS jkyx_recharge (
  id INT(11) NOT NULL AUTO_INCREMENT,
  recharge_money VARCHAR(30) NOT NULL COMMENT "充值金额",
  gift_money VARCHAR(30) NOT NULL DEFAULT '0' COMMENT "赠送金额",
  start_time VARCHAR(40) NOT NULL DEFAULT '' COMMENT "开始时间",
  end_time VARCHAR(40) NOT NULL DEFAULT '' COMMENT "结束时间",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "是否有效  1:正常  2:删除",
  create_time VARCHAR(30) NOT NULL DEFAULT ''  COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充值设置';

CREATE TABLE IF NOT EXISTS jkyx_recharge_record (
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(30) NOT NULL COMMENT "用户ID",
  account VARCHAR(30) NOT NULL DEFAULT '' COMMENT "用户充值的手机号",
  amount VARCHAR(30) NOT NULL DEFAULT '' COMMENT "充值金额",
  mmioashu VARCHAR(250) NOT NULL DEFAULT '' COMMENT "充值描述",
  order_on VARCHAR(40) NOT NULL DEFAULT '' COMMENT "商户订单号",
  transaction_id VARCHAR(100) NOT NULL DEFAULT '' COMMENT "微信支付订单号",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "是否有效  1:正常  2:删除",
  create_time VARCHAR(30) NOT NULL DEFAULT ''  COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='充值记录';





CREATE TABLE IF NOT EXISTS jkyx_home (
  id INT(11) NOT NULL AUTO_INCREMENT,
  index_num VARCHAR(1) NOT NULL COMMENT "序号",
  image_url VARCHAR(250) NOT NULL DEFAULT '' COMMENT "图片地址",
  goods_ids VARCHAR(20) NOT NULL DEFAULT '' COMMENT "商品ID:1,3",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券是否有效  1:正常  2:删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='首页设置';
CREATE TABLE IF NOT EXISTS jkyx_banners (
  id INT(11) NOT NULL AUTO_INCREMENT,
  type VARCHAR(1) NOT NULL COMMENT "类型  1：商品 2：公告",
  image_url VARCHAR(250) NOT NULL DEFAULT '' COMMENT "图片地址",
  goods_id VARCHAR(20) NOT NULL DEFAULT '' COMMENT "商品ID",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券是否有效  1:正常  2:删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='轮播图';

CREATE TABLE IF NOT EXISTS jkyx_coupon (
  id INT(11) NOT NULL AUTO_INCREMENT,
  name VARCHAR(250) NOT NULL DEFAULT '' COMMENT "优惠券 名字",
  type VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券类别：1.新人优惠券 2.全场 优惠券 3.单品优惠券 4.品类优惠券",
  manzu VARCHAR(20) NOT NULL DEFAULT '1' COMMENT "优惠券 满多少",
  youhui VARCHAR(20) NOT NULL DEFAULT '1' COMMENT "优惠券 优惠金额",
  start_time VARCHAR(30) NOT NULL DEFAULT '' COMMENT "优惠券 开始时间",
  end_time VARCHAR(30) NOT NULL DEFAULT '' COMMENT "优惠券 结束时间",
  overdue_time VARCHAR(30) NOT NULL DEFAULT '' COMMENT "优惠券 过期时间",
  available_num INT(11) NOT NULL COMMENT "优惠券 可用数量",
  total_num INT(11) NOT NULL COMMENT "优惠券 总数量",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券是否有效 1.启用 2.停用",
  is_delete VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券是否删除 1.不删除 2.删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "优惠券新建时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='优惠券表';


CREATE TABLE IF NOT EXISTS jkyx_coupon_bind (
  id INT(11) NOT NULL AUTO_INCREMENT,
  coupon_id INT(11)  NOT NULL COMMENT "优惠券ID",
  account_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT "用户ID",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "优惠券是否有效  1:可使用 0：使用记录 2.已过期",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "优惠券新建时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户优惠券表';




CREATE TABLE IF NOT EXISTS access_token (
  id INT(11) NOT NULL AUTO_INCREMENT,
  access_token TEXT NOT NULL DEFAULT '0' COMMENT "access_token",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='access_token缓存记录';

CREATE TABLE IF NOT EXISTS request_list (
  id INT(11) NOT NULL AUTO_INCREMENT,
  telno VARCHAR(11) NOT NULL DEFAULT '' COMMENT "用户手机号",
  request_name VARCHAR(30) NOT NULL DEFAULT '0' COMMENT "接口名",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='PC端请求记录表';
CREATE TABLE IF NOT EXISTS rechange_record (
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT "用户ID",
  amount VARCHAR(11) NOT NULL DEFAULT '0' COMMENT "变化金额",
  type VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态 1：消费 2：退款 3：充值",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态 1：正常 2：删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户余额消费记录表';

CREATE TABLE IF NOT EXISTS mail_admin (
  id INT(11) NOT NULL AUTO_INCREMENT,
  telno VARCHAR(11) NOT NULL DEFAULT '' COMMENT "手机号",
  name VARCHAR(30) NOT NULL DEFAULT '' COMMENT "姓名",
  passwd VARCHAR(40) NOT NULL DEFAULT '' COMMENT "密码  MD5之后的",
  sex VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "性别 1：女 2：男",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态 1：正常 2：删除",
  lastlogin VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "最后一次登录的时间",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='PC管理端人员表'; 
 
CREATE TABLE IF NOT EXISTS orders (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户ID",
  order_no VARCHAR(30) NOT NULL COMMENT "订单号",
  consignee VARCHAR(30) NOT NULL COMMENT "收货人姓名",
  consignee_tel VARCHAR(11) NOT NULL COMMENT "收货人手机号",
  province_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT '省份ID',
  city_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT '城市ID',
  areas_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT '区域ID',
  area_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT '街道ID',
  address varchar(250) NOT NULL DEFAULT '' COMMENT '收获详细地址',
  shooper_id varchar(11) NOT NULL DEFAULT '' COMMENT '配送员ID',
  defray_type varchar(1) NOT NULL DEFAULT '1' COMMENT '配送方式 1：商家配送 2：上门自提',
  defray_id varchar(2) NOT NULL DEFAULT '' COMMENT '自提点ID',
  invoice_type varchar(1) NOT NULL DEFAULT '' COMMENT '发票类型 0：专票 1：普票',
  invoice_name varchar(240) NOT NULL DEFAULT '' COMMENT '发票抬头',
  payment_id varchar(11) NOT NULL DEFAULT '' COMMENT '支付类型ID 1：微信支付 2：支付宝支付 3：余额支付 4：货到付款 5：现金支付 6：微信余额支付',
  freight_amount int(11) unsigned NOT NULL DEFAULT '0' COMMENT '运费',
  amount int(11) unsigned NOT NULL DEFAULT '0' COMMENT '商品总金额',
  pay_amount int(11) unsigned NOT NULL DEFAULT '0' COMMENT '实际支付金额',
  recharge_pay_amount int(11) unsigned NOT NULL DEFAULT '0' COMMENT '使用余额的金额',
  pay_amount_other int(11) unsigned NOT NULL DEFAULT '0' COMMENT '真实微信支付的金额',
  point_amount int(11) unsigned NOT NULL DEFAULT '0' COMMENT '抵用积分金额',
  point_use int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分使用数目',
  pay_timer varchar(20) NOT NULL DEFAULT '' COMMENT '支付时间',
  coupon_id varchar(11) NOT NULL DEFAULT '' COMMENT '优惠券ID',
  order_type varchar(1) NOT NULL DEFAULT '1' COMMENT '订单类型 1：wap订单 2：手工订单 3：淘宝订单',
  order_status varchar(1) NOT NULL DEFAULT '1' COMMENT '订单状态 1：待支付 2：已支付 3：取消 4：已完成 5：待评价 6：已评价 7: 退款',
  is_comment varchar(1) NOT NULL DEFAULT '1' COMMENT '订单评价状态 1：已评价 2：待评价',
  shipping_status varchar(1) NOT NULL DEFAULT '1' COMMENT '配送状态 1：待分配 2：已分配 3：已配送',
  shipping_timer varchar(20) NOT NULL DEFAULT '' COMMENT '配送状态时间 每次状态改变都需要改变这个时间',
  is_print_price varchar(1) NOT NULL DEFAULT '1' COMMENT '是否打印价格单（1是2否）',
  remark varchar(240) NOT NULL DEFAULT '' COMMENT '用户留言',
  descr varchar(240) NOT NULL DEFAULT '' COMMENT '客服备注',
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态1：正常 2：删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "订单创建时间",  
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单记录表'; 

CREATE TABLE IF NOT EXISTS order_goods (
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户ID",
  order_id VARCHAR(30) NOT NULL COMMENT "订单ID",
  goods_id INT(11) NOT NULL COMMENT "购物车中的商品ID",
  spec_id INT(11) NOT NULL COMMENT "规格ID",
  num INT(11) NOT NULL COMMENT "商品数量",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='订单中的商品'; 

CREATE TABLE IF NOT EXISTS footprint (
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户ID",
  goods_id VARCHAR(11) NOT NULL COMMENT "商品ID",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态1：正常 2：删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户浏览足迹'; 
 
CREATE TABLE IF NOT EXISTS collection (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户ID",
  goods_id VARCHAR(11) NOT NULL COMMENT "商品ID",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态1：收藏 2：取消收藏",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品收藏表'; 

CREATE TABLE IF NOT EXISTS hot_search (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  keyword TEXT NOT NULL COMMENT "搜索关键字",
  sort VARCHAR(2) NOT NULL COMMENT "搜索排序值",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "状态1：正常 2：删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='热门搜索配置表';

CREATE TABLE IF NOT EXISTS wx_login (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  openid VARCHAR(11) NOT NULL COMMENT "用户ID",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='微信登录暂储openid表';

CREATE TABLE IF NOT EXISTS cart (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户ID",
  goods_id INT(11) NOT NULL COMMENT "购物车中的商品ID",
  spec_id INT(11) NOT NULL COMMENT "规格ID",
  num INT(11) NOT NULL COMMENT "商品数量",
  status VARCHAR(11) NOT NULL DEFAULT '1' COMMENT "购物车状态，1：正常，2：已经提交订单 3：删除",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='购物车';

CREATE TABLE IF NOT EXISTS imgstore (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  admin_id VARCHAR(11) NOT NULL COMMENT "上传人ID",
  imgpath VARCHAR(250) NOT NULL DEFAULT '' COMMENT "图片地址",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='图片上传记录';

CREATE TABLE IF NOT EXISTS comment (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account_id VARCHAR(11) NOT NULL COMMENT "用户account 手机号",
  order_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT "订单号",
  goods_id VARCHAR(11) NOT NULL DEFAULT '' COMMENT '商品ID',
  content TEXT NOT NULL COMMENT '评价内容',
  images TEXT NOT NULL COMMENT '评价晒图',
  reply TEXT NOT NULL COMMENT '客服回复',
  advice TEXT NOT NULL COMMENT '建议',
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT '1:显示 2：不显示或者删除',
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品评价';

CREATE TABLE IF NOT EXISTS account (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account VARCHAR(11) NOT NULL COMMENT "用户account 手机号",
  pay_password VARCHAR(64) NOT NULL DEFAULT '' COMMENT "支付密码",
  nickname VARCHAR(50) NOT NULL DEFAULT '' COMMENT '昵称',
  birthday VARCHAR(50) NOT NULL DEFAULT '' COMMENT '生日',
  openid VARCHAR(64) NOT NULL DEFAULT '' COMMENT '微信openid',
  balance VARCHAR(11) DEFAULT '0' COMMENT '账户余额（备注1.00元值存100）',
  is_del INT(1) NOT NULL DEFAULT 1 COMMENT '是否删除（1否2是）',
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户会员';

CREATE TABLE IF NOT EXISTS account_identify_code (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account VARCHAR(11) NOT NULL COMMENT "用户account 手机号",
  identify_code INT(6) NOT NULL COMMENT "验证码",
  stauts INT(1) NOT NULL DEFAULT 1 COMMENT '是否删除（1:未使用2:已经使用'),
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户获取的验证码';

CREATE TABLE IF NOT EXISTS sms_logs (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account VARCHAR(11) NOT NULL COMMENT "用户account 手机号",
  template INT(1) NOT NULL COMMENT "1:登录2:修改支付密码3:更改手机号4:充值成功通知5:下单成功通知",
  create_time VARCHAR(20) NOT NULL DEFAULT ''  COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='短信通知记录';
CREATE TABLE IF NOT EXISTS login_logs (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  account VARCHAR(11) NOT NULL COMMENT "用户account 手机号",
  type INT(1) NOT NULL COMMENT "1:登录 2:退出 3:注册",
  ip VARCHAR(20) NOT NULL DEFAULT '' COMMENT "登录、登出时的ip",
  province VARCHAR(20) NOT NULL DEFAULT '' COMMENT "登录、登出时的省份",
  city VARCHAR(20) NOT NULL DEFAULT '' COMMENT "登录、登出时的城市",
  area VARCHAR(20) NOT NULL DEFAULT '' COMMENT "登录、登出时的区",
  create_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户登录,登出记录';
CREATE TABLE IF NOT EXISTS goods (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  goods_id VARCHAR(11) NOT NULL COMMENT "商品原ID",
  name TEXT NOT NULL COMMENT "商品名字",
  descr VARCHAR(250) NOT NULL DEFAULT '' COMMENT "商品描述",
  imgs TEXT NOT NULL COMMENT "商品轮播图",
  detail_imgs TEXT NOT NULL COMMENT "商品详情图",
  status VARCHAR(1) NOT NULL DEFAULT '2' COMMENT "2:上架 3:下架 4:删除",
  sort VARCHAR(3) NOT NULL DEFAULT '0' COMMENT "商品排序",
  pre_sale_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "预售时间戳",
  create_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品列表';

CREATE TABLE IF NOT EXISTS goods_spec (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  goods_id INT(11) NOT NULL COMMENT "商品ID",
  price INT(11) NOT NULL COMMENT "商品销售价格",
  origprice INT(11) NOT NULL COMMENT "商品原价",
  spec VARCHAR(250) NOT NULL DEFAULT '' COMMENT "商品规格",
  salecount INT(11) NOT NULL DEFAULT '0' COMMENT "商品销量",
  erpcode VARCHAR(11) NOT NULL DEFAULT '' COMMENT "商品编号",
  stock INT(11) NOT NULL DEFAULT '0' COMMENT "商品库存",
  status VARCHAR(1) NOT NULL DEFAULT '2' COMMENT "1:有效 2:无效",
  sort VARCHAR(3) NOT NULL DEFAULT '1' COMMENT "商品排序",
  create_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品规格';

CREATE TABLE IF NOT EXISTS goods_classify_relation (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  goods_id INT(10) NOT NULL COMMENT "商品ID",
  classify_id INT(10) NOT NULL COMMENT "商品类别ID",
  create_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "时间戳",
  update_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "更新时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品所属的分类';

CREATE TABLE IF NOT EXISTS goods_classify (  
  id INT(11) NOT NULL AUTO_INCREMENT,
  level INT(10) NOT NULL COMMENT "分类级别",
  pid INT(10) NOT NULL COMMENT "二级分类",
  name VARCHAR(250) NOT NULL DEFAULT '' COMMENT "分类名字",
  descr VARCHAR(250) NOT NULL DEFAULT '' COMMENT "描述",
  logo VARCHAR(250) NOT NULL DEFAULT '' COMMENT "图标",
  sort VARCHAR(3) NOT NULL DEFAULT '' COMMENT "排序",
  status VARCHAR(1) NOT NULL DEFAULT '1' COMMENT "1:显示 2:不显示",
  create_time VARCHAR(20) NOT NULL DEFAULT '' COMMENT "时间戳",
  PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='商品所属的分类';


 */